package com.accp.restaurant.dao;

import com.accp.restaurant.entity.Room;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;

import java.util.List;

public interface RoomDao extends JpaRepository<Room,Long> {

    @Query(value = "select * from Room  where roomname like '%桌%'",nativeQuery = true)
    public List<Room> query();


    public Room findByRoomid(Long roomid);
}
